Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_HIST_ROWCACHE_SUMMARY

`DBA_HIST_ROWCACHE_SUMMARY` displays historical summary statistics for data dictionary activity. This view contains snapshots of `V$ROWCACHE`.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`SNAP_ID` | `NUMBER` |  | Unique snapshot ID
`DBID` | `NUMBER` |  | Database ID for the snapshot
`INSTANCE_NUMBER` | `NUMBER` |  | Instance number for the snapshot
`PARAMETER` | `VARCHAR2(32)` |  | Name of the initialization parameter that determines the number of entries in the data dictionary cache
`TOTAL_USAGE` | `NUMBER` |  | Sum of the total number of entries in the cache
`USAGE` | `NUMBER` |  | Number of cache entries that contain valid data
`GETS` | `NUMBER` |  | Total number of requests for information on the data object
`GETMISSES` | `NUMBER` |  | Number of data requests resulting in cache misses
`SCANS` | `NUMBER` |  | Number of scan requests
`SCANMISSES` | `NUMBER` |  | Number of times a scan failed to find the data in the cache
`SCANCOMPLETES` | `NUMBER` |  | For a list of subordinate entries, the number of times the list was scanned completely
`MODIFICATIONS` | `NUMBER` |  | Number of inserts, updates, and deletions
`FLUSHES` | `NUMBER` |  | Number of times flushed to disk
`DLM_REQUESTS` | `NUMBER` |  | Number of DLM requests
`DLM_CONFLICTS` | `NUMBER` |  | Number of DLM conflicts
`DLM_RELEASES` | `NUMBER` |  | Number of DLM releases